Re: [JBoss-user] Preventing CMP deploy-time CREATE TABLE
I happen to be using JBoss 3.2.1, and it's a CMP 2.0 entity bean. After I sent the email I downloaded and began paging through the O'Reilly JBoss 3.2 Workbook, and learned that I should have set that value in the standardjbosscmp-jdbc.xml file instead. Once I did that it worked like a charm. BTW, that workbook is excellent, it's the clearest book on JBoss I've yet seen. Kudos to the authors. Jason On Friday, June 13, 2003, at 10:47 AM, Dayanand Kangala Shanmugham wrote: Hi, If you are using Jboss 3.0.3, try having the following statements in jbosscmp-jdbc.xml : ... false ... Regards, Dayanand. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jason Wells Sent: Friday, June 13, 2003 10:56 PM To: [EMAIL PROTECTED] Subject: [JBoss-user] Preventing CMP deploy-time CREATE TABLE Hi, I have a CMP entity bean that I plan to use against an existing table. How can it be deployed without issuing a corresponding CREATE TABLE statement? I found docs suggesting that I should have this in my standardjaws.xml: ... false ... I added this, but it doesn't seem to prevent the statement from being fired. Something else I should be doing? Thanks, Jason -- ~~~~~ Jason Wells Semantic Research Inc. [EMAIL PROTECTED] ~ --- This SF.NET email is sponsored by: eBay Great deals on office technology -- on eBay now! Click here: http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user --- This SF.NET email is sponsored by: eBay Great deals on office technology -- on eBay now! Click here: http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user -- ~~~~~ Jason Wells Semantic Research Inc. [EMAIL PROTECTED] ~ --- This SF.NET email is sponsored by: eBay Great deals on office technology -- on eBay now! Click here: http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] Preventing CMP deploy-time CREATE TABLE
Hi, I have a CMP entity bean that I plan to use against an existing table. How can it be deployed without issuing a corresponding CREATE TABLE statement? I found docs suggesting that I should have this in my standardjaws.xml: ... false ... I added this, but it doesn't seem to prevent the statement from being fired. Something else I should be doing? Thanks, Jason -- ~ Jason Wells Semantic Research Inc. [EMAIL PROTECTED] ~ --- This SF.NET email is sponsored by: eBay Great deals on office technology -- on eBay now! Click here: http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] Pointbase setup in JBoss 2.4
Hi, I'm trying to get JBoss 2.4.4 to use Pointbase Embedded 4.1 as a datasource. Does anyone have a sample for the XML I should include in jboss.jcml? Thanks, Jason -- ~ Jason Wells [EMAIL PROTECTED] "The highest moral imperative ICQ: 3241233 is artistic necessity." ~ ___ Have big pipes? SourceForge.net is looking for download mirrors. We supply the hardware. You get the recognition. Email Us: [EMAIL PROTECTED] ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
Re: [JBoss-user] Sybase Datasource problem
John, You didn't give out your JdbcProvider section, so i'm not sure what JDBC driver you're using. I've had good luck with the Sybase JConnect JDBC drivers. If you're using that, this is what the relevant sections of jboss.jcml looks like for my configuration: org.hsql.jdbcDriver,com.sybase.jdbc2.jdbc.SybDriver SybasePool org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl jdbc:sybase:Tds:servername:7100?ELIMINAT_010SM=true username password 0 10 false 120 12 false false true false false 180 1.0 I'm currently running JBoss 2.3 beta, but i used this with JBoss PRE-2.1 and it worked then too (albeit with some minor tweaks IIRC). Hope this helps. Jason - Original Message - From: "John DeStefano" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 18, 2001 10:25 AM Subject: [JBoss-user] Sybase Datasource problem > Hi, > > I'm having a problem with creating a Sybase connection pool. I'm using JBoss 2.2.2 and JDK1.3.1. The startup output looks like this: > > [JNDIView] Starting > [JNDIView] Started > [Transaction manager] Starting > [Transaction manager] Started > [JAAS Security Manager] Starting > [JAAS Security Manager] JAAS.startService, cachePolicy=null > [JAAS Security Manager] JAAS.startService, SecurityProxyFactory=org.jboss.security.SubjectSecurityProxyFactory@4b6009 > [JAAS Security Manager] Started > [JDBC provider] Starting > [JDBC provider] Started > [Hypersonic] Starting > [Hypersonic] Database started > [Hypersonic] Started > [DefaultDS] Starting > [Hypersonic] Server 1.4 is running > [Hypersonic] Press [Ctrl]+[C] to abort > [DefaultDS] XA Connection pool DefaultDS bound to java:/DefaultDS > [DefaultDS] Started > [CensusDS] Starting > [CensusDS] XA Connection pool CensusDS bound to java:/CensusDS > > It hangs at the attempt to bind the Sybase datasource. > > The jboss.jcml section for the sysbase database looks like this: > > > CensusDS > org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImp l > jdbc:sybase:Tds:localhost:2638/census_file_db > dba > 2 > 1 > sql > > false > false > false > true > 12 > 180 > false > false > 1.0 > > > The sybase driver does load according to the server startup output. > > Any help would be appreciated. > > Thanks > > > ___ > JBoss-user mailing list > [EMAIL PROTECTED] > http://lists.sourceforge.net/lists/listinfo/jboss-user ___ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] JDBC config question...
Hello, I'm upgrading from JBoss PRE-2.1 to 2.3 beta. Things were going surprisingly well until I hit this snag. For some reason, my original jboss.jcml configuration for Sybase no longer works. I'm using the JConnect JDBC drivers. This is what I added to/modified in the 2.3 jboss.jcml: org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver,com. sybase.jdbc2.jdbc.SybDriver SybasePool org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl jdbc:sybase:Tds:server:7100?ELIMINAT_010SM=true username password 0 10 false 120 12 false false true false false 180 1.0 This code works fine in the PRE-2.1 release, but in 2.3 I see this in the startup sequence: [JDBC provider] could not load driver:com.sybase.jdbc2.jdbc.SybDriver Later on, it freezes when it gets to creating the connection pool: . . . [SybasePool] Starting [SybasePool] XA Connection pool SybasePool bound to java:/SybasePool (freeze) Thanks in advance, I appreciate any help. -- Jason Wells Web Architect Xsilogy, Inc. http://www.xsilogy.com/ ___ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] SQL query tracing -- how?
Hello, I'm running JBoss 2.1, and I need to turn on SQL tracing so that I can debug a BMP entity bean I'm working on. I'm trying to get my server.log to give me output like this: ... [JAWS] Exists SQL: SELECT COUNT(*) FROM UnitStatus WHERE id=? [JAWS] findAllStatus SQL: SELECT id FROM UnitStatus [JAWS] Create SQL: INSERT INTO UnitStatus (priority,speed,heading,lat) VALUES (?,?,?,?) [JAWS] Remove SQL: DELETE FROM UnitStatus WHERE id=? ... I found no mention of debug in the JBoss docs, but when I searched through the list archive I actually found what appeared to be the answer. It said: "add true to your jaws.xml, at the 'top' level (within the tag, but not in any other. Also, make sure that you're allowing debug level logs to be output." The first part is clear enough, and I took the last part of the instructions ("allow debug level logs to be output") to mean that for my database connection pool in jboss.jcml, set the "LoggingEnabled" attribute to true. Which I did. However, I don't get any SQL statements in either the JBoss console output or in server.log. I assume that I misunderstand the last part. What am I doing wrong? Thanks in advance. -- Jason Wells Web Architect Xsilogy, Inc. http://www.xsilogy.com/ ___ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user
Re: [JBoss-user] CMP finder method problem
Yeah, I know, I'm surprised too, but the SQL statments definitely don't show up anywhere in the server log or the console output. I've gone through it all very thoroughly. Some SQL must be being generated, since one of the entity beans works fine. Yet none of it shows up in the debug. Is there any other debug I can turn on, other than what I've already done: - Adding true to jaws.xml - Adding true to standardjaws.xml - Setting true in standardjboss.xml (under Standard CMP EntityBean, which is what I've written) - Setting true for the connection pool I'm using Did I miss anything? Thanks, Jason - Original Message - From: K.V. Vinay Menon <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 11, 2001 2:35 PM Subject: Re: [JBoss-user] CMP finder method problem > Jason, > The sql statements should appear at server start up in the server log if > you set debug to true in the standardjaws file. They will come be logged > just after the beans are deployed. Am surprised that it is not showing up. > Is there any sql at all being generated? > > Vinay > - Original Message - > From: "Jason Wells" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, May 11, 2001 9:11 PM > Subject: Re: [JBoss-user] CMP finder method problem > > > > I turned all this on, and although I do get additional debug printing from > > the datasource connection pool, I still get no SQL statements in either > the > > console output or in server.log. > > > > Any other ideas? > > > > - Original Message - > > From: <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Friday, May 11, 2001 1:07 AM > > Subject: RE: [JBoss-user] CMP finder method problem > > > > > > > > I could get to the bottom of this if I could just see what > > > > the container is doing when the findAll() is triggered. > > > > My question is: is there a way to print or log the SQL SELECT > > > > statement that the container has executed on my entity bean's > > > > behalf? If not, can anyone suggest a good way to debug > > > > something like this? > > > > > > Yes, you can (there are few places where you can turn logging on and > off): > > > > > > jaws.xml or standardjaws.xml and specify: > > > > > > ... > > > true > > > ... > > > > > > > > > jboss.xml or standardjboss.xml in you CMP container configuration: > > > > > > > > > true > > > > > > in jboss.jcml in your datasource configuration: > > > > > > > > > ... > > > true > > > > > > > > > > > > Also, do not forget to watch the server.log, not the console output, > > because > > > SQL statements appear only in server log (at least in my case). > > > > > > Roman > > > > > > ___ > > > JBoss-user mailing list > > > [EMAIL PROTECTED] > > > http://lists.sourceforge.net/lists/listinfo/jboss-user > > > > > > ___ > > JBoss-user mailing list > > [EMAIL PROTECTED] > > http://lists.sourceforge.net/lists/listinfo/jboss-user > > > ___ > JBoss-user mailing list > [EMAIL PROTECTED] > http://lists.sourceforge.net/lists/listinfo/jboss-user ___ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user
Re: [JBoss-user] CMP finder method problem
I turned all this on, and although I do get additional debug printing from the datasource connection pool, I still get no SQL statements in either the console output or in server.log. Any other ideas? - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 11, 2001 1:07 AM Subject: RE: [JBoss-user] CMP finder method problem > > I could get to the bottom of this if I could just see what > > the container is doing when the findAll() is triggered. > > My question is: is there a way to print or log the SQL SELECT > > statement that the container has executed on my entity bean's > > behalf? If not, can anyone suggest a good way to debug > > something like this? > > Yes, you can (there are few places where you can turn logging on and off): > > jaws.xml or standardjaws.xml and specify: > > ... > true > ... > > > jboss.xml or standardjboss.xml in you CMP container configuration: > > > true > > in jboss.jcml in your datasource configuration: > > > ... > true > > > > Also, do not forget to watch the server.log, not the console output, because > SQL statements appear only in server log (at least in my case). > > Roman > > ___ > JBoss-user mailing list > [EMAIL PROTECTED] > http://lists.sourceforge.net/lists/listinfo/jboss-user ___ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user
Re: [JBoss-user] CMP finder method problem
Unfotunately, I'm not using SQL Server, I'm using Sybase. Anyone know if something like this exists for Sybase? - Original Message - From: Scherr Gerolf <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 11, 2001 1:48 AM Subject: RE: [JBoss-user] CMP finder method problem > if you are using ms sql server, the sql server profiler is a good tool for > debugging purposes. > you can watch connections opening, closing, transactions starting and you > see the sql code that is being sent to the server (useful if you are using > prepared statements, because that seems to be the only way to check if the ? > are being replaced the right way...) > > gerolf. > > > -Ursprüngliche Nachricht- > > Von: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > > Gesendet am: Freitag, 11. Mai 2001 10:08 > > An: [EMAIL PROTECTED] > > Betreff: RE: [JBoss-user] CMP finder method problem > > > > > I could get to the bottom of this if I could just see what > > > the container is doing when the findAll() is triggered. > > > My question is: is there a way to print or log the SQL SELECT > > > statement that the container has executed on my entity bean's > > > behalf? If not, can anyone suggest a good way to debug > > > something like this? > > > > > > ___ > JBoss-user mailing list > [EMAIL PROTECTED] > http://lists.sourceforge.net/lists/listinfo/jboss-user ___ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] CMP finder method problem
Hello, When I call the findAll() method on a CMP entity bean I've written, I'm getting a stack trace containing this exception: java.rmi.ServerException: Store failed; nested exception is: com.sybase.jdbc2.jdbc.SybSQLException: Too many table names or referential constraints in the query, maximum allowed table references is '16'. I don't believe there is any configuration problem mainly because I have a very similar CMP entity bean in the same JAR, using the same database, that seems to work fine. On the other hand, this method is automatically provided by the container, so I don't see how it could be a problem specific to the bean. According to the deployer, the bean deploys correctly with no warnings, which suggests that the deployment descriptors aren't broken. I've gone over them all about six times and I find no problems. I could get to the bottom of this if I could just see what the container is doing when the findAll() is triggered. My question is: is there a way to print or log the SQL SELECT statement that the container has executed on my entity bean's behalf? If not, can anyone suggest a good way to debug something like this? Any help is appreciated. Thanks in advance. -- Jason Wells Web Architect Xsilogy, Inc. http://www.xsilogy.com/ ___ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] JDBC Sybase configuration?
Hello, I'm trying to get JBoss to use the Sybase JConnect 5.2 JDBC driver for CMP entity beans. I've been looking at the "Using MS SQL Server with JBoss" tutorial on the JBoss site, which is the closest thing I've found in terms of relevant documentation: http://www.jboss.org/documentation/HTML/ch11s17.html And actually, it seems pretty applicable. But there's one area where the instructions aren't too useful, because they vary considerably from driver to driver, and that's the connection pool MBean declaration. I'm thinking it would look something like this... com.sybase.jdbcx.SybDataSource SybasePool ??? user=dbusername; password=dbpassword 4 10 false 120 12 false false true false false 180 1.0 But, I have no idea how to formulate the JDBC URL, or if it's even needed. Also, I wonder if I need "JDBCUser" and "Password" attributes. All of these things seem to vary from driver to driver. Has anyone set this up for the Sybase JDBC driver? Any help is appreciated. Thanks, Jason ___ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] EAR deployment with Jboss/Tomcat
Hello, A basic question... I'm trying to deploy a very simple servlet that calls a very simple stateless session bean. Our configuration has Apache integrated with Tomcat/Jboss (embedded). I've been following these instructions: http://www.jboss.org/business/jboss-tomcat.html I have a web archive (ejbHello.war) containing a servlet called ejbHelloServlet. This servlet uses a stateless session bean called ejbHello, which is in a JAR called ejbHello.jar. These have been combined into an EAR called ejbHello.ear. The application.xml file in the EAR sets the context root as /ejbHello. The EAR is deployed in the Jboss /deploy directory. Which is great, except that when I visit the URL, which I believe (according to the instructions) should be http://localhost:8082/ejbHello, I get a 404. What am I doing wrong here? One area that makes me suspicious is at the end of the instructions, where it says "for your application to be visible through Apache, you must setup the appropriate JkMount statements in mod_jk.conf." However, it doesn't mention what the 'appropriate statements' are. Any help is appreciated... thanks in advance. -- Jason Wells Web Architect Xsilogy, Inc. http://www.xsilogy.com/ ___ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] Basic jsp --> ejb example for Jboss?
Hello, I'm new to the EJB world and I'm trying to find a "hello world" level explanation/tutorial that walks through creating a very basic web application (using Jboss) that accesses EJB services from within a JSP or servlet. When I looked through the online Jboss docs, I found a tutorial which suggests that you download example code... but when I tried, I repeatedly got a 404. I've also dug through the listserv archive, and found nothing that seemed especially germane to this problem. I've also rifled through the java.sun.com/jGuru J2EE tutorials, but they seem to rely on vendor-specific tools for crucial parts of the code deployment procedure. (Since their example was based on Weblogic, it isn't very useful in the Jboss world.) I'm not sure where else to turn. This seems like a problem anyone would have to get through in order to create a web application using Jboss. Surely there must be some kind of resource (at least a mini-howto, or something!) just to help people get started. My configuration is Apache/Tomcat/Jboss running on RH6.2. Any help is appreciated. Thanks in advance. -- Jason Wells Web Architect Xsilogy, Inc. http://www.xsilogy.com/ ___ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user