4:20 p.m.
Hey guys, quick question:
Does seam-persistence provide any mechanism that handles jdbc connections
and sql native queries?
4:21 p.m.
afaik, it doesn't, but maybe a feature or two escaped from my eyes.
On Fri, Nov 25, 2011 at 1:20 PM, José Rodolfo Freitas <
joserodolfo.freitas(a)gmail.com> wrote:
Hey guys, quick question:
Does seam-persistence provide any mechanism that handles jdbc connections
and sql native queries?
6:32 p.m.
No it does not, JPA only.
Sent from my iPhone
On Nov 25, 2011, at 8:21, José Rodolfo Freitas <joserodolfo.freitas(a)gmail.com>
wrote:
afaik, it doesn't, but maybe a feature or two escaped from my
eyes.
On Fri, Nov 25, 2011 at 1:20 PM, José Rodolfo Freitas
<joserodolfo.freitas(a)gmail.com> wrote:
Hey guys, quick question:
Does seam-persistence provide any mechanism that handles jdbc connections and sql native
queries?
_______________________________________________
seam-dev mailing list
seam-dev(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/seam-dev
6:39 p.m.
Maybe we need a Seam JDBC module.
On Fri, Nov 25, 2011 at 12:32 PM, Jason Porter <lightguard.jp(a)gmail.com>wrote:
No it does not, JPA only.
Sent from my iPhone
On Nov 25, 2011, at 8:21, José Rodolfo Freitas <
joserodolfo.freitas(a)gmail.com> wrote:
afaik, it doesn't, but maybe a feature or two escaped from my eyes.
On Fri, Nov 25, 2011 at 1:20 PM, José Rodolfo Freitas <
joserodolfo.freitas(a)gmail.com> wrote:
> Hey guys, quick question:
> Does seam-persistence provide any mechanism that handles jdbc connections
> and sql native queries?
>
>
>
>
_______________________________________________
seam-dev mailing list
seam-dev(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/seam-dev
_______________________________________________
seam-dev mailing list
seam-dev(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/seam-dev
9:07 p.m.
Yeah, a JBDC module would be very useful. Eventually I cross with
requirements that asks for JDBC connections. Essentially for perfomance
with gigantic queries and reports.
On Fri, Nov 25, 2011 at 3:39 PM, John D. Ament <john.d.ament(a)gmail.com>wrote:
Maybe we need a Seam JDBC module.
On Fri, Nov 25, 2011 at 12:32 PM, Jason Porter <lightguard.jp(a)gmail.com>wrote:
> No it does not, JPA only.
>
> Sent from my iPhone
>
> On Nov 25, 2011, at 8:21, José Rodolfo Freitas <
> joserodolfo.freitas(a)gmail.com> wrote:
>
> afaik, it doesn't, but maybe a feature or two escaped from my eyes.
>
> On Fri, Nov 25, 2011 at 1:20 PM, José Rodolfo Freitas <
> joserodolfo.freitas(a)gmail.com> wrote:
>
>> Hey guys, quick question:
>> Does seam-persistence provide any mechanism that handles jdbc
>> connections and sql native queries?
>>
>>
>>
>>
> _______________________________________________
> seam-dev mailing list
> seam-dev(a)lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/seam-dev
>
>
> _______________________________________________
> seam-dev mailing list
> seam-dev(a)lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/seam-dev
>
>
9:32 p.m.
Here here.
I know the biggest issue I always run into is stored procedure invocation.
Something really easy to implement would be binding stored procedures (not
ones that return results, just do work) to interface methods
public interface SomePackageNameOrDboOrSchemaName{
@StoredProcedure("someProcedureName(?,?,?)")
public void someProcedureName(String s, int i, Long l);
}
And do automatic binding of the method args to the procedure invocation.
For result sets, I always find it easier to just bind it as a JPA query.
On Fri, Nov 25, 2011 at 3:07 PM, José Rodolfo Freitas <
joserodolfo.freitas(a)gmail.com> wrote:
Yeah, a JBDC module would be very useful. Eventually I cross with
requirements that asks for JDBC connections. Essentially for perfomance
with gigantic queries and reports.
On Fri, Nov 25, 2011 at 3:39 PM, John D. Ament <john.d.ament(a)gmail.com>wrote:
> Maybe we need a Seam JDBC module.
>
>
> On Fri, Nov 25, 2011 at 12:32 PM, Jason Porter <lightguard.jp(a)gmail.com>wrote:
>
>> No it does not, JPA only.
>>
>> Sent from my iPhone
>>
>> On Nov 25, 2011, at 8:21, José Rodolfo Freitas <
>> joserodolfo.freitas(a)gmail.com> wrote:
>>
>> afaik, it doesn't, but maybe a feature or two escaped from my eyes.
>>
>> On Fri, Nov 25, 2011 at 1:20 PM, José Rodolfo Freitas <
>> joserodolfo.freitas(a)gmail.com> wrote:
>>
>>> Hey guys, quick question:
>>> Does seam-persistence provide any mechanism that handles jdbc
>>> connections and sql native queries?
>>>
>>>
>>>
>>>
>> _______________________________________________
>> seam-dev mailing list
>> seam-dev(a)lists.jboss.org
>> https://lists.jboss.org/mailman/listinfo/seam-dev
>>
>>
>> _______________________________________________
>> seam-dev mailing list
>> seam-dev(a)lists.jboss.org
>> https://lists.jboss.org/mailman/listinfo/seam-dev
>>
>>
>
11:01 p.m.
Back in my day JPA and createNativeQuery used to do the trick. ;)
http://en.wikibooks.org/wiki/Java_Persistence/Advanced_Topics#Stored_Proc...
On Fri, Nov 25, 2011 at 1:32 PM, John D. Ament <john.d.ament(a)gmail.com>wrote:
Here here.
I know the biggest issue I always run into is stored procedure
invocation. Something really easy to implement would be binding stored
procedures (not ones that return results, just do work) to interface methods
public interface SomePackageNameOrDboOrSchemaName{
@StoredProcedure("someProcedureName(?,?,?)")
public void someProcedureName(String s, int i, Long l);
}
And do automatic binding of the method args to the procedure invocation.
For result sets, I always find it easier to just bind it as a JPA query.
On Fri, Nov 25, 2011 at 3:07 PM, José Rodolfo Freitas <
joserodolfo.freitas(a)gmail.com> wrote:
> Yeah, a JBDC module would be very useful. Eventually I cross with
> requirements that asks for JDBC connections. Essentially for perfomance
> with gigantic queries and reports.
>
>
> On Fri, Nov 25, 2011 at 3:39 PM, John D. Ament <john.d.ament(a)gmail.com>wrote:
>
>> Maybe we need a Seam JDBC module.
>>
>>
>> On Fri, Nov 25, 2011 at 12:32 PM, Jason Porter
<lightguard.jp(a)gmail.com>wrote:
>>
>>> No it does not, JPA only.
>>>
>>> Sent from my iPhone
>>>
>>> On Nov 25, 2011, at 8:21, José Rodolfo Freitas <
>>> joserodolfo.freitas(a)gmail.com> wrote:
>>>
>>> afaik, it doesn't, but maybe a feature or two escaped from my eyes.
>>>
>>> On Fri, Nov 25, 2011 at 1:20 PM, José Rodolfo Freitas <
>>> joserodolfo.freitas(a)gmail.com> wrote:
>>>
>>>> Hey guys, quick question:
>>>> Does seam-persistence provide any mechanism that handles jdbc
>>>> connections and sql native queries?
>>>>
>>>>
>>>>
>>>>
>>> _______________________________________________
>>> seam-dev mailing list
>>> seam-dev(a)lists.jboss.org
>>> https://lists.jboss.org/mailman/listinfo/seam-dev
>>>
>>>
>>> _______________________________________________
>>> seam-dev mailing list
>>> seam-dev(a)lists.jboss.org
>>> https://lists.jboss.org/mailman/listinfo/seam-dev
>>>
>>>
>>
>
_______________________________________________
seam-dev mailing list
seam-dev(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/seam-dev
--
Daniel Hinojosa
Programmer, Instructor, and Consultant
dhinojosa(a)evolutionnext.com
http://www.evolutionnext.com
http://www.abqjug.org
11:17 p.m.
Hi,
It smells like a challenge for cdi-query extension guys ;)
--
BR,
Michal
On 25.11.2011 21:32, John D. Ament wrote:
Here here.
I know the biggest issue I always run into is stored procedure
invocation. Something really easy to implement would be binding stored
procedures (not ones that return results, just do work) to interface methods
public interface SomePackageNameOrDboOrSchemaName{
@StoredProcedure("someProcedureName(?,?,?)")
public void someProcedureName(String s, int i, Long l);
}
And do automatic binding of the method args to the procedure invocation.
For result sets, I always find it easier to just bind it as a JPA query.
On Fri, Nov 25, 2011 at 3:07 PM, José Rodolfo Freitas
<joserodolfo.freitas(a)gmail.com <mailto:joserodolfo.freitas@gmail.com>>
wrote:
Yeah, a JBDC module would be very useful. Eventually I cross with
requirements that asks for JDBC connections. Essentially for
perfomance with gigantic queries and reports.
On Fri, Nov 25, 2011 at 3:39 PM, John D. Ament
<john.d.ament(a)gmail.com <mailto:john.d.ament@gmail.com>> wrote:
Maybe we need a Seam JDBC module.
On Fri, Nov 25, 2011 at 12:32 PM, Jason Porter
<lightguard.jp(a)gmail.com <mailto:lightguard.jp@gmail.com>> wrote:
No it does not, JPA only.
Sent from my iPhone
On Nov 25, 2011, at 8:21, José Rodolfo Freitas
<joserodolfo.freitas(a)gmail.com
<mailto:joserodolfo.freitas@gmail.com>> wrote:
> afaik, it doesn't, but maybe a feature or two escaped from
> my eyes.
>
> On Fri, Nov 25, 2011 at 1:20 PM, José Rodolfo Freitas
> <joserodolfo.freitas(a)gmail.com
> <mailto:joserodolfo.freitas@gmail.com>> wrote:
>
> Hey guys, quick question:
> Does seam-persistence provide any mechanism that
> handles jdbc connections and sql native queries?
>
>
>
>
> _______________________________________________
> seam-dev mailing list
> seam-dev(a)lists.jboss.org <mailto:seam-dev@lists.jboss.org>
> https://lists.jboss.org/mailman/listinfo/seam-dev
_______________________________________________
seam-dev mailing list
seam-dev(a)lists.jboss.org <mailto:seam-dev@lists.jboss.org>
https://lists.jboss.org/mailman/listinfo/seam-dev
_______________________________________________
seam-dev mailing list
seam-dev(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/seam-dev
11:54 a.m.
Taken ;) https://github.com/ctpconsulting/query/issues/17
There is already support in for native SQL queries, but not too fancy yet -
feel free to leave a comment on the issue.
On Sat, Nov 26, 2011 at 11:17 PM, michal.kaplon(a)poczta.fm <
michal.kaplon(a)poczta.fm> wrote:
Hi,
It smells like a challenge for cdi-query extension guys ;)
--
BR,
Michal
On 25.11.2011 21:32, John D. Ament wrote:
> Here here.
>
> I know the biggest issue I always run into is stored procedure
> invocation. Something really easy to implement would be binding stored
> procedures (not ones that return results, just do work) to interface
methods
>
> public interface SomePackageNameOrDboOrSchemaName{
>
> @StoredProcedure("someProcedureName(?,?,?)")
> public void someProcedureName(String s, int i, Long l);
> }
>
> And do automatic binding of the method args to the procedure invocation.
>
> For result sets, I always find it easier to just bind it as a JPA query.
>
> On Fri, Nov 25, 2011 at 3:07 PM, José Rodolfo Freitas
> <joserodolfo.freitas(a)gmail.com <mailto:joserodolfo.freitas@gmail.com>>
> wrote:
>
> Yeah, a JBDC module would be very useful. Eventually I cross with
> requirements that asks for JDBC connections. Essentially for
> perfomance with gigantic queries and reports.
>
>
> On Fri, Nov 25, 2011 at 3:39 PM, John D. Ament
> <john.d.ament(a)gmail.com <mailto:john.d.ament@gmail.com>> wrote:
>
> Maybe we need a Seam JDBC module.
>
>
> On Fri, Nov 25, 2011 at 12:32 PM, Jason Porter
> <lightguard.jp(a)gmail.com <mailto:lightguard.jp@gmail.com>>
wrote:
>
> No it does not, JPA only.
>
> Sent from my iPhone
>
> On Nov 25, 2011, at 8:21, José Rodolfo Freitas
> <joserodolfo.freitas(a)gmail.com
> <mailto:joserodolfo.freitas@gmail.com>> wrote:
>
>> afaik, it doesn't, but maybe a feature or two escaped from
>> my eyes.
>>
>> On Fri, Nov 25, 2011 at 1:20 PM, José Rodolfo Freitas
>> <joserodolfo.freitas(a)gmail.com
>> <mailto:joserodolfo.freitas@gmail.com>> wrote:
>>
>> Hey guys, quick question:
>> Does seam-persistence provide any mechanism that
>> handles jdbc connections and sql native queries?
>>
>>
>>
>>
>> _______________________________________________
>> seam-dev mailing list
>> seam-dev(a)lists.jboss.org <mailto:seam-dev@lists.jboss.org>
>> https://lists.jboss.org/mailman/listinfo/seam-dev
>
> _______________________________________________
> seam-dev mailing list
> seam-dev(a)lists.jboss.org <mailto:seam-dev@lists.jboss.org>
> https://lists.jboss.org/mailman/listinfo/seam-dev
>
>
>
>
>
>
> _______________________________________________
> seam-dev mailing list
> seam-dev(a)lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/seam-dev
_______________________________________________
seam-dev mailing list
seam-dev(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/seam-dev
9:25 p.m.
If it helps, I use these two methods with JPA to call Stored Procedures /
Functions:
protected Object executeFunction(EntityManager entityManager, String
functionName, Object... params) {
StringBuilder functionStr = new StringBuilder(functionName);
functionStr.append("(");
for (int i = 1; i <= params.length; i++) {
functionStr.append("?").append(i);
functionStr.append(",");
}
functionStr.deleteCharAt(functionStr.length() - 1);
functionStr.append(")");
Query nativeQuery = entityManager.createNativeQuery("SELECT " +
functionStr.toString() + " FROM DUAL");
for (int i = 1; i <= params.length; i++) {
nativeQuery.setParameter(i, params[i - 1]);
}
return nativeQuery.getSingleResult();
}
protected Object executeFunctionUpdate(DataSource dataSource, String
functionName, Object... params) {
StringBuilder functionStr = new StringBuilder(functionName);
functionStr.append("(");
for (int i = 1; i <= params.length; i++) {
functionStr.append("?,");
}
functionStr.deleteCharAt(functionStr.length() - 1);
functionStr.append(")");
String sqlString = "{? = call " + functionStr.toString() +
"}";
Connection con = null;
CallableStatement call = null;
try {
con = dataSource.getConnection();
call = con.prepareCall(sqlString);
call.registerOutParameter(1, java.sql.Types.NUMERIC);
for (int i = 1; i <= params.length; i++) {
call.setObject(i + 1, params[i - 1]);
}
call.execute();
return call.getObject(1);
} catch (SQLException se) {
throw new GvtIntegraException(se);
} finally {
DBUtil.closeQuietly(con, call, null);
}
}
2011/11/26 michal.kaplon(a)poczta.fm <michal.kaplon(a)poczta.fm>
Hi,
It smells like a challenge for cdi-query extension guys ;)
--
BR,
Michal
On 25.11.2011 21:32, John D. Ament wrote:
> Here here.
>
> I know the biggest issue I always run into is stored procedure
> invocation. Something really easy to implement would be binding stored
> procedures (not ones that return results, just do work) to interface
methods
>
> public interface SomePackageNameOrDboOrSchemaName{
>
> @StoredProcedure("someProcedureName(?,?,?)")
> public void someProcedureName(String s, int i, Long l);
> }
>
> And do automatic binding of the method args to the procedure invocation.
>
> For result sets, I always find it easier to just bind it as a JPA query.
>
> On Fri, Nov 25, 2011 at 3:07 PM, José Rodolfo Freitas
> <joserodolfo.freitas(a)gmail.com <mailto:joserodolfo.freitas@gmail.com>>
> wrote:
>
> Yeah, a JBDC module would be very useful. Eventually I cross with
> requirements that asks for JDBC connections. Essentially for
> perfomance with gigantic queries and reports.
>
>
> On Fri, Nov 25, 2011 at 3:39 PM, John D. Ament
> <john.d.ament(a)gmail.com <mailto:john.d.ament@gmail.com>> wrote:
>
> Maybe we need a Seam JDBC module.
>
>
> On Fri, Nov 25, 2011 at 12:32 PM, Jason Porter
> <lightguard.jp(a)gmail.com <mailto:lightguard.jp@gmail.com>>
wrote:
>
> No it does not, JPA only.
>
> Sent from my iPhone
>
> On Nov 25, 2011, at 8:21, José Rodolfo Freitas
> <joserodolfo.freitas(a)gmail.com
> <mailto:joserodolfo.freitas@gmail.com>> wrote:
>
>> afaik, it doesn't, but maybe a feature or two escaped from
>> my eyes.
>>
>> On Fri, Nov 25, 2011 at 1:20 PM, José Rodolfo Freitas
>> <joserodolfo.freitas(a)gmail.com
>> <mailto:joserodolfo.freitas@gmail.com>> wrote:
>>
>> Hey guys, quick question:
>> Does seam-persistence provide any mechanism that
>> handles jdbc connections and sql native queries?
>>
>>
>>
>>
>> _______________________________________________
>> seam-dev mailing list
>> seam-dev(a)lists.jboss.org <mailto:seam-dev@lists.jboss.org>
>> https://lists.jboss.org/mailman/listinfo/seam-dev
>
> _______________________________________________
> seam-dev mailing list
> seam-dev(a)lists.jboss.org <mailto:seam-dev@lists.jboss.org>
> https://lists.jboss.org/mailman/listinfo/seam-dev
>
>
>
>
>
>
> _______________________________________________
> seam-dev mailing list
> seam-dev(a)lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/seam-dev
_______________________________________________
seam-dev mailing list
seam-dev(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/seam-dev
4527
days inactive
4529
days old
9 comments
7 participants
participants (7)
-
Daniel Hinojosa -
George Gastaldi -
Jason Porter -
John D. Ament -
José Rodolfo Freitas -
michal.kaplon＠poczta.fm -
Thomas Hug