hi,
i am using database scheduler service in jboss ie DBScheduleProvider. For this i am using
Sybase as database.As i doing all the configuration, i am not able to fetch data through
DBSchedulerProvider.
Sybase Database Configuration
Sybase Adaptive Server Enterprise (ASE) is a database server by Sybase Inc. ASE is used on
both UNIX and Linux platforms. As before, the first step is getting the database driver
classes into the CLASSPATH, by copying the .jar file jconn2.jar to the /server/default/lib
directory. Then use its data source by copying /docs/examples/jca/sybase-ds.xml to
/server/default/deploy dir.
Modify the sybase-ds.xml configuration file, setting <driver-class/> to
com.sybase.jdbc2.jdbc.SybDriver and <connection-url/> to jdbc:sybase:Tds::/, where
is the Sybase host server, is the Sybase host server port number, and is the Sybase
database name.
Then, as before, we need to modify standardjaws.xml or jaws.xml to set the
and<type-mapping> elements:
java:/SybaseDS
<type-mapping>Sybase</type-mapping>
We also need to modify standardjbosscmp-jdbc.xml or jbosscmp-jdbc.xml to set the and
<datasource-mapping> elements:
<jbosscmp-jdbc>
java:/SybaseDS
<datasource-mapping>Sybase</datasource-mapping>
</jbosscmp-jdbc>Finally, we modify login-config.xml to use the Sybase database. Add
the following <application-policy/> element to the file:
<application-policy name = "SybaseDbRealm">
<login-module code =
"org.jboss.resource.security.ConfiguredIdentityLoginModule"
flag = "required">
<module-option name ="principal">sa</module-option>
<module-option name = "userName">sa</module-option>
<module-option name = "password"></module-option>
<module-option name = "managedConnectionFactoryName">
jboss.jca:service=LocalTxCM,name=SybaseDS
</module-option>
</login-module>
</application-policy>By modifying the sybase-ds.xml, standardjaws.xml,
standardjbosscmp-jdbc.xml, and login-config.xml, the JBoss 4.0 server is configured to be
used with a Sybase database.
---
After done this also, i am still getting error. I dont know why it is coming.
If any one knows the solution, help me.
thanks in advance
by
chandrasekar
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4037561#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...