[JBoss-user] [JBoss Seam] - Re: Does JBoss Seam work with SQL Server 2000?
One last thing, but obviously removing the schema and catalog qualifiers means that each table name should be unique. Otherwise, I am sure something nasty will happen. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3949630#3949630 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3949630 ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JBoss Seam] - Re: Does JBoss Seam work with SQL Server 2000?
Oh and thanks for the pointers, Gavin and Rorschach. It got me pointed towards the 'work-around' solution. Unfortunately, I still haven't figured out the source of the actual problem. -MLA View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3949496#3949496 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3949496 ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JBoss Seam] - Re: Does JBoss Seam work with SQL Server 2000?
So I changed to the jTDS drivers, but I got the same problem. So then I went
in and manually just whacked the schema and catalog identifiers from the class
file, and then reran the ant build file. Voila, no more problems.
So what have I learned? I am not really sure, but here's what is working for
me:
When using: JBoss 4.0.4 GA (ejb config)
JBoss Seam 1.0.0CR3
MS Sql Server 2000
MS or jTDS JDBC Drivers
1. Follow the basic steps of create java project, create hibernate config,
create Hibernate reverse engineering code generator. (see the SEAM CRUD Example
for details)
2. Run the code generator.
3. Follow the readme file up to the point of running the Ant script. Hold off
on that.
4. Replace all:
'import javax.ejb.Interceptors;'
with
'import javax.interceptor.Interceptors;'
5. Replace all:
@In
private transient ResourceBundle resourceBundle;
with
@In(create = true)
private transient ResourceBundle resourceBundle;
6. Replace all:
@Table(name = "table_name", schema = "dbo", catalog = "TST_DB",
uniqueConstraints = {})
with
@Table(name = "table_name", uniqueConstraints = {})
7. Run the Ant script and startup JBoss 4.0.4 GA.
Hopefully, this helps someone else.
-MLA
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3949495#3949495
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3949495
___
JBoss-user mailing list
JBoss-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JBoss Seam] - Does JBoss Seam work with SQL Server 2000?
All, I have been working for about a week off and on and cannot even get the simple CRUD application working with a SQL Server 2000 database. I will post the stacktrace at message end, but I was curious if anyone has had success using SEAM with SQL Server 2000? I am using the Microsoft JDBC drivers, but I would be happy to try any others that might work. Thanks in advance, -MLA Here's the stacktrace: 2006-06-06 12:13:59,046 DEBUG [org.jboss.seam.contexts.Contexts] found in session context: resourceBundle 2006-06-06 12:13:59,046 DEBUG [org.jboss.mx.loading.RepositoryClassLoader] setRepository, [EMAIL PROTECTED], [EMAIL PROTECTED] url=null ,addedOrder=0} 2006-06-06 12:13:59,078 DEBUG [org.hibernate.loader.Loader] loading entity: [com.lrn.rm.test.City#0] 2006-06-06 12:13:59,093 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0) 2006-06-06 12:13:59,093 DEBUG [org.hibernate.jdbc.ConnectionManager] opening JDBC connection 2006-06-06 12:13:59,093 DEBUG [org.hibernate.SQL] select city0_.id as id0_0_, city0_.name as name0_0_, city0_.country as country0_0_, city0_.zipcode as zipcode0_0_ from TST_SEAM.dbo.city city0_ where city0_.id=? 2006-06-06 12:13:59,093 INFO [STDOUT] Hibernate: select city0_.id as id0_0_, city0_.name as name0_0_, city0_.country as country0_0_, city0_.zipcode as zipcode0_0_ from TST_SEAM.dbo.city city0_ where city0_.id=? 2006-06-06 12:13:59,093 DEBUG [org.hibernate.util.JDBCExceptionReporter] could not load an entity: [com.lrn.rm.test.City#0] [select city0_.id as id0_0_, city0_.name as name0_0_, city0_.country as country0_0_, city0_.zipcode as zipcode0_0_ from TST_SEAM.dbo.city city0_ where city0_.id=?] java.sql.SQLException: Three part identifiers prohibited in statement [select city0_.id as id0_0_, city0_.name as name0_0_, city0_.country as country0_0_, city0_.zipcode as zipcode0_0_ from TST_SEAM.dbo.city city0_ where city0_.id=?] at org.hsqldb.jdbc.Util.throwError(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:349) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:337) at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:187) at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:497) at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:415) at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139) at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561) at org.hibernate.loader.Loader.doQuery(Loader.java:661) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.loadEntity(Loader.java:1785) at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48) at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42) at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:2821) at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:370) at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:351) at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:122) at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:178) at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:86) at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:871) at org.hibernate.impl.SessionImpl.get(SessionImpl.java:808) at org.hibernate.impl.SessionImpl.get(SessionImpl.java:801) at org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:155) at com.lrn.rm.test.CityEditorBean.create(CityEditorBean.java:70) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112) at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166) at org.jboss.seam.interceptors.SeamInvocationContext.proceed(SeamInvocationContext.java:56) at org.jboss.seam.interceptors.ValidationInterce
[JBoss-user] [JBoss Seam] - Re: Three part identifiers prohibited in statement
Here is a portion of the stacktrace. Please let me know if more would be helpful. Also, please note that this is the same problem, but this is for a different schema than the example. In this scenario, I used a single table from an existing database project in hopes of reducing the problem set. If it would be helpful, I can rerun the example schema: java.sql.SQLException: Three part identifiers prohibited in statement [select top ? locs0_.ID as ID145_, locs0_.Name as Name145_, locs0_.State as State145_, locs0_.City as City145_, locs0_.Zip as Zip145_, locs0_.Comments as Comments145_, locs0_.OID as OID145_, locs0_.Phone_Prim as Phone8_145_, locs0_.Phone_Sec as Phone9_145_, locs0_.Address_Line_1 as Address10_145_, locs0_.Address_Line_2 as Address11_145_ from LOC_LC.dbo.Locs locs0_ where locs0_.Name like ?] at org.hsqldb.jdbc.Util.throwError(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:349) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:337) at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:187) at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:497) at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:415) at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139) at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561) at org.hibernate.loader.Loader.doQuery(Loader.java:661) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2145) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029) at org.hibernate.loader.Loader.list(Loader.java:2024) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:392) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:333) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1109) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:53) at com.lrn.rm.deploy.labman.locsFinderBean.executeQuery(locsFinderBean.java:134) at com.lrn.rm.deploy.labman.locsFinderBean.findFirstPage(locsFinderBean.java:140) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:109) at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:168) at org.jboss.seam.interceptors.SeamInvocationContext.proceed(SeamInvocationContext.java:56) at org.jboss.seam.interceptors.ValidationInterceptor.validateTargetComponent(ValidationInterceptor.java:64) at sun.reflect.GeneratedMethodAccessor144.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.jboss.seam.util.Reflections.invoke(Reflections.java:13) at org.jboss.seam.interceptors.Interceptor.aroundInvoke(Interceptor.java:87) at org.jboss.seam.interceptors.SeamInvocationContext.proceed(SeamInvocationContext.java:60) at org.jboss.seam.interceptors.OutcomeInterceptor.interceptOutcome(OutcomeInterceptor.java:21) at sun.reflect.GeneratedMethodAccessor143.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.jboss.seam.util.Reflections.invoke(Reflections.java:13) at org.jboss.seam.interceptors.Interceptor.aroundInvoke(Interceptor.java:87) at org.jboss.seam.interceptors.SeamInvocationContext.proceed(SeamInvocationContext.java:60) at org.jboss.seam.interceptors.RollbackInterceptor.rollbackIfNecessary(RollbackInterceptor.java:30) at sun.reflect.GeneratedMethodAccessor142.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.jboss.seam.util.Reflections.invoke(Reflections.java:13) at or
[JBoss-user] [JBoss Seam] - Re: Three part identifiers prohibited in statement
Ok, let's try a different angle: 1. Has anyone got Seam working with MS Sql Server 2000? 2. Has anyone seen this excpetion before? Is anyone familiar with what it means? Is the primary key being ignored? Thanks again for any help anyone can offer. -MLA View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3948971#3948971 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3948971 ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JBoss Seam] - Three part identifiers prohibited in statement
All, I am using: Jboss seam 1.0.0.CR3 JBoss IDE 1.6 JBoss 4.0.4GA (ejb3 config) SQL Server 2000 MS SQL Server 200 JDBC drivers I am trying to complete the CRUD example from the example movie. I get everything up and running and go to the web interface and try to run a search and I get the following issue. I have tried a variety of things, but I consistently receive the exception: Three part identifiers prohibited in statement I copied the sql statement from the stack trace and ran it against the SQL Server db (replacing the ?'s with values) using Sql Server's Query Analyzer and the sql statement runs fine. Is anyone familiar with this exception? I apologize if this is more of a JDBC related issue, but I am at a loss for where to start on this one. Thanks, -MLA View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3948552#3948552 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3948552 ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Management, JMX/JBoss] - Invoke causes Status 500 HTTP Error
Hi all, Hopefully, this issue has not been covered elsewhere. I have seen this behaviour on 3.2.3 and 3.2.6. Basically, after starting JBoss 3.2.6 (all server config), a user can go to http://somehost.com:/jmx-console and view the jmx-console. Additionally, a user can click on a link, such as JNDIView to see the related details. However, if a user clicks on ANY of the Invoke buttons, the requested action is completed, but the resulting HTTP response is a Status 500 message. Therefore, to stop delivery for a MDB, this is only a minor annoyance, but for informational responses, such as JNDIView, it is completely disabling. Here is an example of the output from server.log when a user has attempted to invoke the list method (verbose=true) under JNDIView: 2005-01-13 10:24:44,622 DEBUG [org.apache.coyote.tomcat5.CoyoteAdapter] Requested cookie session id is B83D0B468D096513CFD726018AD6935F 2005-01-13 10:24:44,622 DEBUG [org.apache.catalina.core.StandardWrapper] Returning non-STM instance 2005-01-13 10:24:44,623 DEBUG [org.apache.catalina.core.ApplicationDispatcher] servletPath=/inspectMBean.jsp, pathInfo=null, queryString=null, name=null 2005-01-13 10:24:44,623 DEBUG [org.apache.catalina.core.ApplicationDispatcher] Path Based Forward 2005-01-13 10:24:44,624 DEBUG [org.apache.catalina.core.StandardWrapper] Returning non-STM instance 2005-01-13 10:24:44,624 DEBUG [org.apache.jasper.servlet.JspServlet] JspEngine --> /inspectMBean.jsp 2005-01-13 10:24:44,624 DEBUG [org.apache.jasper.servlet.JspServlet] ServletPath: /inspectMBean.jsp 2005-01-13 10:24:44,624 DEBUG [org.apache.jasper.servlet.JspServlet] PathInfo: null 2005-01-13 10:24:44,624 DEBUG [org.apache.jasper.servlet.JspServlet] RealPath: /opt/jboss-3.2.6-prod/server/all/deploy/jmx-console.war/inspectMBean.jsp 2005-01-13 10:24:44,624 DEBUG [org.apache.jasper.servlet.JspServlet] RequestURI: /jmx-console/inspectMBean.jsp 2005-01-13 10:24:44,624 DEBUG [org.apache.jasper.servlet.JspServlet] QueryString: action=inspectMBean&name=jboss%3Aservice%3DJNDIView 2005-01-13 10:24:44,624 DEBUG [org.apache.jasper.servlet.JspServlet] Request Params: 2005-01-13 10:24:44,625 DEBUG [org.apache.jasper.servlet.JspServlet] action = inspectMBean 2005-01-13 10:24:44,625 DEBUG [org.apache.jasper.servlet.JspServlet] name = jboss:service=JNDIView 2005-01-13 10:24:44,637 DEBUG [org.apache.catalina.core.ApplicationDispatcher] Disabling the response for futher output 2005-01-13 10:24:44,840 DEBUG [org.apache.catalina.core.StandardWrapper] Returning non-STM instance 2005-01-13 10:24:48,963 DEBUG [org.apache.coyote.tomcat5.CoyoteAdapter] Requested cookie session id is B83D0B468D096513CFD726018AD6935F 2005-01-13 10:24:48,964 DEBUG [org.apache.catalina.core.StandardWrapper] Returning non-STM instance 2005-01-13 10:24:48,989 DEBUG [org.apache.catalina.core.ApplicationDispatcher] servletPath=/displayOpResult.jsp, pathInfo=null, queryString=null, name=null 2005-01-13 10:24:48,989 DEBUG [org.apache.catalina.core.ApplicationDispatcher] Path Based Forward 2005-01-13 10:24:48,989 DEBUG [org.apache.catalina.core.StandardWrapper] Returning non-STM instance 2005-01-13 10:24:48,989 DEBUG [org.apache.jasper.servlet.JspServlet] JspEngine --> /displayOpResult.jsp 2005-01-13 10:24:48,989 DEBUG [org.apache.jasper.servlet.JspServlet] ServletPath: /displayOpResult.jsp 2005-01-13 10:24:48,989 DEBUG [org.apache.jasper.servlet.JspServlet] PathInfo: null 2005-01-13 10:24:48,990 DEBUG [org.apache.jasper.servlet.JspServlet] RealPath: /opt/jboss-3.2.6-prod/server/all/deploy/jmx-console.war/displayOpResult.jsp 2005-01-13 10:24:48,990 DEBUG [org.apache.jasper.servlet.JspServlet] RequestURI: /jmx-console/displayOpResult.jsp 2005-01-13 10:24:48,990 DEBUG [org.apache.jasper.servlet.JspServlet] QueryString: null 2005-01-13 10:24:48,990 DEBUG [org.apache.jasper.servlet.JspServlet] Request Params: 2005-01-13 10:24:48,990 DEBUG [org.apache.jasper.servlet.JspServlet] methodIndex = 0 2005-01-13 10:24:48,990 DEBUG [org.apache.jasper.servlet.JspServlet] action = invokeOp 2005-01-13 10:24:48,990 DEBUG [org.apache.jasper.servlet.JspServlet] arg0 = True 2005-01-13 10:24:48,990 DEBUG [org.apache.jasper.servlet.JspServlet] name = jboss:service=JNDIView 2005-01-13 10:24:48,993 ERROR [org.jboss.web.localhost.Engine] ApplicationDispatcher[/jmx-console] Servlet.service() for servlet jsp threw exception java.lang.NoSuchFieldError: args at org.apache.jsp.displayOpResult_jsp._jspService(displayOpResult_jsp.java:88) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324) at org.apache.jasper.
[JBoss-user] [Installation & Configuration] - Configure Hypersonic data location
Hi all, I am sure this has been posted already, but I have not been able to find it. How can I specify the location of the generated files for hypersonic? I am using 3.2.3. Currently, the default setting is writing localDB.* to the deploy directory which results in a host of ZipExceptions. Thanks in advance, -MLA View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3834430#3834430 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3834430 --- This SF.Net email is sponsored by Sleepycat Software Learn developer strategies Cisco, Motorola, Ericsson & Lucent use to deliver higher performing products faster, at low TCO. http://www.sleepycat.com/telcomwpreg.php?From=osdnemail3 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JCA/JBoss] - Re: Conection leak in 3.2.1
Adrian, Thanks for responding. I am seeing ResourceExceptions due to connection failures. Is there anything I can do to resolve this leak situation without Moving off the JBoss 3.2.1 platform? Thanks in advance for any info you or anyone else can offer. -MLA View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3830144#3830144 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3830144 --- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JCA/JBoss] - Conection leak in 3.2.1
Hi All, If memory serves, someone mentioned that 3.2.1 has a known connection leak issue. I have not been able to find this info again and was hoping someone might be able to supply some info on the issue and what work-arounds/fixes might exist. Thanks in advance, -MLA View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3830001#3830001 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3830001 --- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JCA/JBoss] - Re: Network Problem while accessing database: Connection res
Ok, now I'm confused. Did you try adding an ExceptionSorter? If so, and you are still seeing the problem, then I am stumped. If not, then knock yourself out. If you are confused about how to implement or deploy an ExceptionSorter, then as I said, do a search on the JBoss Forums for ExceptionSorter (several threads on the subject). -MLA View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3828862#3828862 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3828862 --- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JCA/JBoss] - Re: JBoss Connection Pool for non-DB resource
I decided to go with the rar. I simply updated my -ds.xml file to include two connection factories ( same rar for both ) which point to different IP Addresses. The code requests a connection from the primary connection factory. If the connection fails or is unavailable or throws an exception, then the failure is handled and an attempt is made to retrieve a connection from the backup connection factory. That's the solution that seemed to meet my needs the best. Thanks for the help Adrian. For the sake of others who might be going the rar route, I found the following helpful: create a jar file which contains the javax.resource classes for jca 1.x and then extend these classes for your rar. Also, the URL Adrian lists has some great example code to get you going in the right direction. Finally, I found it helpful to start with no config-properties and just 'hardcoded' future config-properties in the class, getting it deployed successfully, and then adding the getters and setters for the config-properties and adding them to the -ds.xml file appropriately. This made it extremely easy to id config-properties that were not capitalized properly or for which the type was wrong, etc. Hope that is helpful, -MLA View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3828612#3828612 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3828612 --- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JCA/JBoss] - Re: Network Problem while accessing database: Connection res
It may be helpful to post your mssql-ds.xml file, but without seeing it, my guess is
that you need to add an ExceptionSorter and a check-valid-sql tag to your
mssql-ds.xml. Something like this:
someDataSource
jdbc:microsoft:sqlserver://someUrl:1433;DatabaseName=someDb;SelectMethod=cursor
com.microsoft.jdbc.sqlserver.SQLServerDriver
someUser
somePass
com.yourpkg.SqlServerExceptionSorter
10
20
select count(*) from SomeConnectionTest
The sql used should be very fast. In my example SomeConnectionTest is a one column
table with only one row. Also, you will have to develop an ExceptionSorter, but there
are several examples in the docs directory. Essentially, try this:
public class SqlServerExceptionSorter implements ExceptionSorter, Serializable
{
public SqlServerExceptionSorter()
{
} // SqlServerExceptionSorter constructor
public boolean isExceptionFatal(SQLException e)
{
return true;
}
} // SqlServerExceptionSorter
...if you want all Exceptions thrown by the JDBC driver to force the Connection to be
removed from the connection pool.
Finally, a search for ExceptionSorter and valid-connection-sql on this forum will
result in a lot of answers to this situation that may have more helpful info.
Hope this all helps,
-MLA
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3828562#3828562
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3828562
---
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JCA/JBoss] - Re: Network Problem while accessing database: Connection res
It may be helpful to post your mssql-ds.xml file, but without seeing it, mt guess is
that you need to an exceptionsorter and a check-valid-sql tag to your mssql-ds.xml.
Something like this:
someDataSource
jdbc:microsoft:sqlserver://someUrl:1433;DatabaseName=someDb;SelectMethod=cursor
com.microsoft.jdbc.sqlserver.SQLServerDriver
someUser
somePass
com.yourpkg.SqlServerExceptionSorter
10
20
select count(*) from SomeConnectionTest
The sql used should be very fast. In my example SomeConnectionTest is a one column
table with only one row that is never changed. Also, you will have to develop an
ExceptionSorter, but there are several examples in the docs directory. Essentially,
try this:
public class SqlServerExceptionSorter implements ExceptionSorter, Serializable
{
public SqlServerExceptionSorter()
{
} // SqlServerExceptionSorter constructor
public boolean isExceptionFatal(SQLException e)
{
return true;
}
} // SqlServerExceptionSorter
if you want all Exceptions thrown to force the Connection to be removed from the
connection pool.
Finally, a search for ExceptionSorter and valid-connection-sql on this forum will
result in a lot of answers to this situation that may have more helpful info.
Hope this all helps,
-MLA
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3828558#3828558
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3828558
---
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Messaging, JMS & JBossMQ] - Considering File PersistenceManager
All, I am using JBoss-3.2.1 w/Tomcat. I am currently using hypersonic to manage persistence, but I am considering moving to something else. Because persistence/delivery is a MUST for all the messages, I am looking at the File PM. I was curious if anyone had used this and, if they had, any recommendations. I am primarily concerned with the fact that the jbossmq-service.xml states that to restart a JBoss server, the 'directory must be empty'. What exactly does this mean? Specifically, is this stating that all undelivered message data must be removed? That seems counter intuitive. I assume I am misunderstanding something here. I am also interested in opinions on the performance numbers attained by the File PM (msg/sec). Thanks in advance, -MLA http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3825873#3825873";>View the original post http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3825873>Reply to the post --- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Messaging, JMS & JBossMQ] - Re: JMS Queue Not flushing
Actually, I think all is working, but I was a bit panicked this morning. :) Anyways, I have found that the JMS Messages are now in the DLQ. Is there a way to resend these messages? Can I so it from the JMX-Console? Thanks in advance, -MLA http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3825701#3825701";>View the original post http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3825701>Reply to the post --- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Messaging, JMS & JBossMQ] - Re: JMS Queue Not flushing
Also, is it possible to initiate a queue flush from the JMX-Console? Thanks, -MLA http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3825700#3825700";>View the original post http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3825700>Reply to the post --- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Messaging, JMS & JBossMQ] - JMS Queue Not flushing
All, I am running JBOss 3.2.1- TOmcat Bundle. I have a large JMS Queue which on restart will not begin flushing. This has worked in the past, but now it is not. Where should I be looking for info on this problem? The localDB.script file is huge. ANy hsqldb logs out there? Thanks in advance for any help anyone can offer, -MLA http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3825699#3825699";>View the original post http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3825699>Reply to the post --- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence & CMP/JBoss] - A single database access until cached data is invalidated
All, I have a CMP for a small database table that contains pretty static data. I would like for the CMP to make a single access to the database to load all of the rows in the table into cache. Once the data has been loaded, I would like the CMP to be completely independent of the database; such that if the database fails or changes, the CMP will never 'know', but instead, it will continue to return the cached data. I have tried commit-option A, read-only, etc., but to no avail. Is this situation not appropriate to a CMP? Will lost connections always cause Exceptions? Any and all input on this subject would be appreciated. Thanks, -MLA http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3825370#3825370";>View the original post http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3825370>Reply to the post --- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Connectors and JCA/JBoss] - Re: JBoss Connection Pool for non-DB resource
Essentially, I have an application that sends many requests to another server. Additionally, if this server is unreachable, there are fail-over servers to which I need to make future requests until the primary servers come back online. What I would like to do is have a Primary Server Connection Pool and a FailOver Server Connection Pool. The FailOver Server Connection Pool would largely be ignored, unless there was a problem, and the FailOVer Server Connection Pool would utilize a different IP Address, but essentially both pools would be identical otherwise. If indeed developing a ResourceAdapter seems to be the logical solution, any advice on where to look for info on developing/deploying a ResourceAdapter for Jboss3.2.1? Thanks, -MLA View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3822954#3822954 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3822954 --- SF.Net is sponsored by: Speed Start Your Linux Apps Now. Build and deploy apps & Web services for Linux with a free DVD software kit from IBM. Click Now! http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Connectors and JCA/JBoss] - JBoss Connection Pool for non-DB resource
All, How would I go about setting up a container managed connection pool? Ideally, it would be similar to the same methodology that is implemented for datasources. Thanks, -MLA View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3822905#3822905 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3822905 --- SF.Net is sponsored by: Speed Start Your Linux Apps Now. Build and deploy apps & Web services for Linux with a free DVD software kit from IBM. Click Now! http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Connectors and JCA/JBoss] - Re: JBoss Connection Pool for non-DB resource
Oops, I left out that I am trying to do this on JBoss 3.2.1. Thanks, -MLA View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3822906#3822906 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3822906 --- SF.Net is sponsored by: Speed Start Your Linux Apps Now. Build and deploy apps & Web services for Linux with a free DVD software kit from IBM. Click Now! http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
