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#4037561
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4037561
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
